# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2021年10月08日
"""
import pandas as pd

path = '../数据文件/课件013-014/条件判断.xlsx'

# 有日期查询时,一定要把日期设置为列索引

data = pd.read_excel(path,index_col='序号')
data.loc[data['性别'] == '男', '称呼'] = '先生'
data.loc[data['性别'] == '男', '称呼'] = '女士'

print(data.head())